use Inventory
go
INSERT INTO Roles VALUES('AD','Admin',4)
INSERT INTO Roles VALUES('SM','Sales Manager',2)
INSERT INTO Roles VALUES('IM','Inventory Manager',1)
INSERT INTO Roles VALUES('SS','Sales Men',3)
go
insert into Users
values('U01','AD','MrToanDH','admin','admin','01677239979','babyhachi@gmail.com','Hai phong',null,0)
insert into Users
values('U02','SM','MrThangVV','sales','123456','01677239979','babyhachi@gmail.com','Hai phong',null,1)
insert into Users
values('U03','IM','MrDuyDog','inven','123456','01677239979','babyhachi@gmail.com','Hai phong',null,1)
insert into Users
values('U04','SS','MrCuiMia','sale','123456','01677239979','babyhachi@gmail.com','Hai phong',null,1)
go


insert into Categories values('Vegetable',1)
insert into Categories values('Fruit',1)
insert into Categories values('Fast Food',1)
insert into Categories values('Fashion',1)
insert into Categories values('Tools',1)
insert into Categories values('Machine',1)
insert into Categories values('Electronic',1)
insert into Categories values('Intertaiment',1)
insert into Categories values('Technology',1)
insert into Categories values('Other',1)


go

insert into Items values('I01',2,'Apple','KG',10,12,1)
insert into Items values('I02',2,'Oranges','KG',10,16,1)
insert into Items values('I03',2,'Coconutt','KG',10,17,1)
insert into Items values('I04',2,'Grapes','KG',10,11,1)
insert into Items values('I05',3,'KFC','Count',10,11,1)
insert into Items values('I06',3,'Coffee','Count',10,15,1)
insert into Items values('I07',4,'Clothing','Count',10,13,1)
insert into Items values('I08',4,'Pants','Count',10,14,1)
insert into Items values('I09',4,'Hat','Count',10,15,1)
insert into Items values('I10',7,'TV','Count',10,10,1)
insert into Items values('I11',7,'Computer','Count',10,128,1)
insert into Items values('I12',7,'Phone','Count',10,125,1)
insert into Items values('I13',4,'Shoes','Count',10,17,1)
insert into Items values('I14',4,'Sandals','Count',10,18,1)
insert into Items values('I15',3,'Cakes','Count',10,15,1)
insert into Items values('I16',2,'Peach','KG',10,15,1)
insert into Items values('I17',2,'Cherry','KG',10,14,1)
insert into Items values('I18',6,'Fan','Cont',10,125,1)
insert into Items values('I19',6,'Sewing Machines','Cont',10,125,1)
insert into Items values('I20',6,'Pump','Cont',10,125,1)

select * from Customers 

go
insert into Customers values('Nguyen Duy','duynd@gmail.com','PT','0972483312',1,'VT','VN',1,null)
insert into Customers values('Dinh Toan','thangvvd@gmail.com','HP','0943245534',1,'HP','VN',1,7)
insert into Customers values('Vu Thang','toandh@gmail.com','HN','0974326566',1,'HN','VN',1,3)
insert into Customers values('Nguyen Tuan','tuan@gmail.com','BN','0974326554',1,'BN','VN',1,4)
insert into Customers values('Nguyen Hoang','hoang@gmail.com','KG','0972483423',1,'KG','VN',1,7)
insert into Customers values('Vu Anh','anh@gmail.com','TH','0972483333',0,'TH','VN',1,8)
insert into Customers values('Tran Kien','kien@gmail.com','HB','0972483653',1,'HB','VN',1,9)
insert into Customers values('Hoang Dat','dat@gmail.com','ND','0972483086',1,'ND','VN',0,2)
insert into Customers values('Vi Hung','hung@gmail.com','SG','0972483673',1,'SG','VN',1,6)
insert into Customers values('Nguyen Huong','huong@gmail.com','BP','0972483261',0,'BP','VN',0,11)
insert into Customers values('Pham Tien','tien@gmail.com','VP','0972483084',1,'VP','VN',1,12)
insert into Customers values('Vu Linh','linh@gmail.com','LA','0972483864',0,'LA','VN',1,6)
insert into Customers values('Dinh Loan','loan@gmail.com','HY','0972483385',0,'HY','VN',0,4)

GO
insert into Customers values('Dinh Huy Toan','ToanDH@Gmail.com','Ha Noi','01677249552',1,'Ha Noi','Viet Nam',1,null)
insert into Customers values('Vu Van Thang','ThangVV@Gmail.com','Hai Phong','01677249552',1,'Ha Noi','Viet Nam',1,null)
insert into Customers values('Barck Obama','B.Obama@Gmail.com','USA','013547513',1,'California','USA',1,345.2154)
insert into Customers values('Michel Jackson','MJ@Gmail.com','USA','0165741354',1,'New York','USA',1,235.657)=======
go
insert into Bills values('U01',1,'9/12/2010',4,'Visa',20,1)
insert into Bills values('U01',1,'1/12/2010',8,'Visa',20,0)
insert into Bills values('U01',1,'2/12/2010',4,'MasterCard',19,0)
insert into Bills values('U01',6,'6/11/2010',15,'MasterCard',20,1)
insert into Bills values('U01',7,'8/16/2010',54,'Visa',32,1)
insert into Bills values('U01',8,'1/23/2010',23,'Visa',43,0)
insert into Bills values('U01',11,'2/22/2010',54,'MasterCard',50,0)
insert into Bills values('U01',12,'1/3/2010',11,'MasterCard',32,1)

insert into Bills values('U02',1,'9/25/2010',7,'DisCover',15,1)
insert into Bills values('U02',2,'9/12/2010',11,'Visa',21,1)
insert into Bills values('U02',2,'4/12/2010',13,'MasterCard',22,1)
insert into Bills values('U02',5,'12/11/2010',43,'Visa',45,0)
insert into Bills values('U02',8,'5/14/2010',54,'Visa',19,0)
insert into Bills values('U02',1,'7/12/2010',32,'Visa',14,1)
insert into Bills values('U02',9,'8/12/2010',15,'Visa',53,1)
insert into Bills values('U02',12,'1/12/2010',35,'Visa',23,0)

insert into Bills values('U03',2,'8/15/2010',5,'MasterCard',26,1)
insert into Bills values('U03',7,'2/18/2010',7,'Visa',26,1)
insert into Bills values('U03',9,'4/16/2010',5,'MasterCard',27,0)
insert into Bills values('U03',6,'3/15/2010',5,'Visa',25,1)
insert into Bills values('U03',10,'11/4/2010',35,'Visa',43,0)
insert into Bills values('U03',11,'12/5/2010',24,'Visa',54,0)
insert into Bills values('U03',5,'10/15/2010',15,'Visa',23,1)
insert into Bills values('U03',13,'10/10/2010',31,'Visa',65,1)

insert into Bills values('U04',3,'6/12/2010',12,'Visa',14,1)
insert into Bills values('U04',11,'2/12/2010',43,'MasterCard',16,1)
insert into Bills values('U04',12,'3/12/2010',34,'Visa',43,0)
insert into Bills values('U04',13,'9/12/2010',23,'MasterCard',65,1)
insert into Bills values('U04',5,'10/12/2010',54,'Visa',34,0)
insert into Bills values('U04',3,'12/12/2010',12,'MasterCard',23,1)

go
insert into BillDetails values(1,'I01',5,123)
insert into BillDetails values(2,'I02',6,324)
insert into BillDetails values(3,'I01',11,654)
insert into BillDetails values(4,'I03',21,213)
insert into BillDetails values(5,'I05',23,324)
insert into BillDetails values(5,'I04',43,112)
insert into BillDetails values(6,'I06',31,546)
insert into BillDetails values(7,'I07',21,236)
insert into BillDetails values(8,'I08',43,653)
insert into BillDetails values(10,'I02',54,435)
insert into BillDetails values(11,'I01',35,654)
insert into BillDetails values(12,'I02',20,393)
insert into BillDetails values(13,'I05',38,385)
insert into BillDetails values(9,'I03',53,384)
insert into BillDetails values(1,'I05',47,493)
insert into BillDetails values(1,'I04',49,384)
insert into BillDetails values(1,'I06',39,482)
insert into BillDetails values(1,'I07',37,683)
